package com.community.charge.mapper;

import com.community.charge.domain.vo.HouseVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface HouseVoMapper {

    //根据楼宇绑定房屋下拉框
    @Select("select house_id as houseId, room_no as roomNo from house where building_id=#{id}")
    List<HouseVo> getHouseVoNameAndId(Integer id);

    //绑定搜索框的房屋下拉框
    @Select("select house_id as houseId, room_no as roomNo from house")
    List<HouseVo> getHouseVoIdAndName();
}
